CREATE EXTERNAL TABLE jms_dwd.`dwd_task_pre_rel_yarn_dt` (
  `dag_id`                  string,
  `task_id`                 string,
  `start_date`              string,
  `end_date`                string,
  `duration`                string,
  `run_id`                  string,
  `last_state`                   string,
  `try_number`              string,
  `max_tries`               string,
  `hostname`                string,
  `unixname`                string,
  `job_id`                  string,
  `pool`                    string,
  `pool_slots`              string,
  `priority_weight`         string,
  `operator`                string,
  `queued_dttm`             string,
  `queued_by_job_id`        string,
  `pid`                     string,
  `executor_config`         string,
  `updated_at`              string,
  `external_executor_id`    string,
  `trigger_id`              string,
  `trigger_timeout`         string,
  `next_method`             string,
  `num_executors`           string,
  `executor_cores`          string,
  `executor_memory`         string,
  `driver_cores`            string,
  `driver_memory`           string,
  `yarn_queue`              string,
  `memory_overhead`         string,
  `max_executors`           string,
  `spark_partitions`        string,
  `yarn_name`               string,
  `rendered_fields`         string,
  `grad_time` string  COMMENT "抓取时间",
  `app_id` string  COMMENT "任务id",
  `user` string  COMMENT "用户名称",
  `queue` string  COMMENT "队列",
  `type` string  COMMENT "任务类型",
  `Vcores` bigint  COMMENT "cpu核数",
  `mem_MB` bigint  COMMENT "内存MB",
  `usage` string  COMMENT "使用占比",
  `state` string  COMMENT "任务状态"
) COMMENT '登录日志表'
PARTITIONED BY (
  `dt` string COMMENT '创建日期 (yyyy-MM-dd)')
stored as parquet
location '/dw/hive/jms_dwd.db/external/dwd_task_pre_rel_yarn_dt'